Hi,

we've set up a Sharepoint 2013 Server which usually comes with FIM 2010 Sync Manager. We would now like to add a synchronisation of our AD to an SQL table as outlined here:

https://technet.microsoft.com/en-us/library/ff608275%28v=ws.10%29.aspx

But in the list of Management Agents, SQL Server is missing.

We do not own a dedicated FIM 2010 license. Is the SQL Server Management Agent only part of the full version of this product or can we add the SQL Agent by downloading some add-on or upgrading to FIM 2010 R2?

Thanks for your help, Tom.

Hello,

Yes SharePoint 2013 came with a built-in sync engine as part of the user Profile Service.

But this is a very limited Version and only fr using as part of User Profile Server.

You can not add other MAs like in FIM and it is also not supported as far as I know.

So you will have to license a FIM Version in order to connect your SQL.

-Peter

To add to that, once you have the full blown FIM, you will have 2 IDM systems (in some way); 1. the User Profile Service (the one you have now) and the real FIM.  The two will not share anything, so if you need to centralize identities, you need to consider this.

There is a SharePoint Connector for FIM to let FIM be the User Profile Service instead using that one that comes with FIM.

See: https://msdn.microsoft.com/en-us/library/dn511003%28v=ws.10%29.aspx?f=255&MSPPError=-2147217396

and you can download it here: http://www.microsoft.com/en-us/download/details.aspx?id=41164

-Peter